CREATE TABLE [dbo].[Product_Lot]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_PRODUCT_CODE] DEFAULT (''),
[LOCATION] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_LOCATION] DEFAULT (''),
[LOT_SERIAL] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_LOT_SERIAL] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_TITLE] DEFAULT (''),
[BIN] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_BIN] DEFAULT (''),
[ON_HAND] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Lot_ON_HAND] DEFAULT ((0)),
[RESERVED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Lot_RESERVED] DEFAULT ((0)),
[COMMITTED_QTY] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Lot_COMMITTED_QTY] DEFAULT ((0)),
[AVAILABLE] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Lot_AVAILABLE] DEFAULT ((0)),
[AVAILABLE_KEY] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Lot_AVAILABLE_KEY] DEFAULT (''),
[LOT_DATE] [datetime] NULL,
[BACKORDERED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Lot_BACKORDERED] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Lot] ADD CONSTRAINT [PK_Product_Lot] PRIMARY KEY CLUSTERED ([PRODUCT_CODE], [LOCATION], [LOT_SERIAL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_LotAVAILABLE_KEY] ON [dbo].[Product_Lot] ([AVAILABLE_KEY]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Lot] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Lot] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Lot] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Lot] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Lot] TO [IMIS]
GO